UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FHTHS6vx+bbWoxSJoK7D22fj4uIeN4eTQG3hAfd3qe0='
WHERE
key_id = '7ef7dbe8a07d28993835f6a638792acdcd6f62b496dcc275910f217ea24bb5bd'
AND (
token = 'FHTHS6vx+bbWoxSJoK7D22fj4uIeN4eTQG3hAfd3qe0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)