UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0d0YCZIwc0vQA2CJ4LR0m6XTFHRFtQj40HOTOxXW+qM='
WHERE
key_id = '27fce81a2e2350340bdd24a708c4a9d925f77cab15b6ae1522095f507b333cf2'
AND (
token = '0d0YCZIwc0vQA2CJ4LR0m6XTFHRFtQj40HOTOxXW+qM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)