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