UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CP40SQwr5QVER/CCkzOHlZKOV3FMoISXbHCsUUmpBx4='
WHERE
key_id = 'aa2f54e729bc7bc937c8a84ad09f107228a2144ec38860f9812fc37b22bd2d46'
AND (
token = 'CP40SQwr5QVER/CCkzOHlZKOV3FMoISXbHCsUUmpBx4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)