UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rFb/rEyk4Nfamern7Reg4971QPqg0oos0kmeCRrAP20='
WHERE
key_id = '7f4210824c45b6549369e3448816e3edd62f2339957921a8df753bf6d1812cdd'
AND (
token = 'rFb/rEyk4Nfamern7Reg4971QPqg0oos0kmeCRrAP20='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)