UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5CZZgx91+5MQ3x0O4PwGlPIXWuk+KSsp0wgqU9ndwOw='
WHERE
key_id = '6d3bb028bf96f9119fda6595139a9cd4710a72e9763629ce2d4fdb1d11efb235'
AND (
token = '5CZZgx91+5MQ3x0O4PwGlPIXWuk+KSsp0wgqU9ndwOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)