UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qTWUNjcyWkuWKCkcjf6LcEsGRuHuep/LEJ/DFB3t24M='
WHERE
key_id = 'f9a2086630fb2c6ea31660bcc2c9f6c66a948761a1fc579cb838ae9957b40636'
AND (
token = 'qTWUNjcyWkuWKCkcjf6LcEsGRuHuep/LEJ/DFB3t24M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)