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