UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9jKc/i7YDQlokW0OGAOrbkDNB1l1JTEfOvYF4RtjwJc='
WHERE
key_id = 'b6eae70bc5ae5f9dade95046de92033cd18112c57c59c0dcf16d349c9ebd5e28'
AND (
token = '9jKc/i7YDQlokW0OGAOrbkDNB1l1JTEfOvYF4RtjwJc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)