UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xiGsz0kgvJixVb/3o+eJ4XrGN3a/D00zvexmhK7bTnY='
WHERE
key_id = 'df0bb3b82b5e1f267bc037c398b422ac766be7e60d1bc4d96422835d85dea13e'
AND (
token = 'xiGsz0kgvJixVb/3o+eJ4XrGN3a/D00zvexmhK7bTnY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)