UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YF1HEWGkx0G7nlVRXnQ1f3NZllXox4GEEO4yjVBTVOI='
WHERE
key_id = 'a01704361d6357bc13cbe53f85614ca8fcc6796e18b36498910134e83a8e8238'
AND (
token = 'YF1HEWGkx0G7nlVRXnQ1f3NZllXox4GEEO4yjVBTVOI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)