UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xY00xQx3Jk+xARxkcAEtPFBOLSeYyoE4WCIH7Y2BwdQ='
WHERE
key_id = 'd695076c5b4616e1e62e79249c2069e24c552e9be894fd5fa0eb06739bb88a82'
AND (
token = 'xY00xQx3Jk+xARxkcAEtPFBOLSeYyoE4WCIH7Y2BwdQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)