UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fD26erH/bJl7Kryv4NKfqi1znPntcgAcQ/nxDwdW6xY='
WHERE
key_id = '6bde70cd92b6069b82676a480162cbedd39f0c98ee6ed686706848ced146aa1d'
AND (
token = 'fD26erH/bJl7Kryv4NKfqi1znPntcgAcQ/nxDwdW6xY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)