UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4NSaNb4RyVnPuWltiCZpIwwkOfTlNLaRNAbL77SALHw='
WHERE
key_id = '9339ede7168bfb847444efb7368bc1728e99ab511dbc575e9bf60f966815d3b6'
AND (
token = '4NSaNb4RyVnPuWltiCZpIwwkOfTlNLaRNAbL77SALHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)