UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'brUx3PDMNoS0HqnQr9VeAUFYNRrAlpLI0pGJDp60C94='
WHERE
key_id = 'f298ca643af1928826ab1b7324a7e613d842094e7fb70a9651ea27117d808606'
AND (
token = 'brUx3PDMNoS0HqnQr9VeAUFYNRrAlpLI0pGJDp60C94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)