UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CgtehlqkVatv7zgAGPEbXmtdnvxCLyQTpeFOvsKBTnY='
WHERE
key_id = '58828dc8df50abe9e951e4b1201ed81b291ade4becda1b8bebda3e1426d31332'
AND (
token = 'CgtehlqkVatv7zgAGPEbXmtdnvxCLyQTpeFOvsKBTnY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)