UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zU4am1HrWRU+HPnjpsmsjarl/Lsx4rlkwepSz1EDJa4='
WHERE
key_id = '9e367c0bcb914bced8f0dc7056ed7c886b95464edf93094dd24324dc454295e8'
AND (
token = 'zU4am1HrWRU+HPnjpsmsjarl/Lsx4rlkwepSz1EDJa4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)