UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E4wHOHcdNUEJQvh6EX2mVcPRxtHrZdcVypN26inCXzE='
WHERE
key_id = '87e38e68e6f2f9358a4f0e504d2dbe8c25777b026bc74cf4d635272da90c19d6'
AND (
token = 'E4wHOHcdNUEJQvh6EX2mVcPRxtHrZdcVypN26inCXzE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)