UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9FUJ1aYFAZZjyMNUF5s2NiUz5mMNXwqSA5UH5i+iaPQ='
WHERE
key_id = '24247b2f421e68093355a94ac29d28ae39ecdfe50a236a8f04d19f5acdf1bf63'
AND (
token = '9FUJ1aYFAZZjyMNUF5s2NiUz5mMNXwqSA5UH5i+iaPQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)