UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pc+jtA7BVNEkFjZM+SGDKYFvkYzB14TJieRWTqGwOS8='
WHERE
key_id = '6966dc8b931bd133564b6cc7adda7b93b3e3b2ae6b4f538965af7ec70fa55215'
AND (
token = 'pc+jtA7BVNEkFjZM+SGDKYFvkYzB14TJieRWTqGwOS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)