UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XDFps1wXjDWGTiT+VYmuWKnFT9Jm3rh7zeRnFBv8Ez8='
WHERE
key_id = '100ecce1bde60be0d98b74fc38cc0207801b458e5087d4b32885abc6eb2cc32c'
AND (
token = 'XDFps1wXjDWGTiT+VYmuWKnFT9Jm3rh7zeRnFBv8Ez8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)