UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ipYelZC7ZuVHxuzYHnYR2nE/6y/NGyB30bB7Ky9LTzY='
WHERE
key_id = '871548f29f2d927c8b2dd773903b89783a5e2b49ff84d2939ef890b1cf54c58d'
AND (
token = 'ipYelZC7ZuVHxuzYHnYR2nE/6y/NGyB30bB7Ky9LTzY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)