UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CdYlc7zR6ltUp1UvgFJf4GGvdjmOmJpYZE/o0BJqCE8='
WHERE
key_id = 'a0ed75b7f1fc2bce1a198c30a2f60cba6010d4e1d457b9e8ea035b40777e37ee'
AND (
token = 'CdYlc7zR6ltUp1UvgFJf4GGvdjmOmJpYZE/o0BJqCE8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)