UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X6F8PdznNwYZZq5vJV4gADJtZSHGns4dE1CevLUhxD4='
WHERE
key_id = '1660cc50c9db7a692e49590c495c0a60c256e8afbefdb5aaa9ae74ddf4adf19a'
AND (
token = 'X6F8PdznNwYZZq5vJV4gADJtZSHGns4dE1CevLUhxD4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)