UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DE9kXDBa0/jxzOFq83u7OM3YWJOG79ZxunGgrNyHFf8='
WHERE
key_id = 'ad6a83d630e461beb2daac6efb793bcf996dea50ce53a67ac94d578da1e1b626'
AND (
token = 'DE9kXDBa0/jxzOFq83u7OM3YWJOG79ZxunGgrNyHFf8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)