UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q4l+jR5SchhfqsUHn9ka4aU8tgbXvj6YfzN4PEKN710='
WHERE
key_id = '562e34b416cb8b498a6eccd4753532f10befa4bacbe094a5dd77cbf507b88eab'
AND (
token = 'q4l+jR5SchhfqsUHn9ka4aU8tgbXvj6YfzN4PEKN710='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)