UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TFpQ6CvCpErCqAefHB9XMxzlR5duJItxwIub0v/s1Vc='
WHERE
key_id = 'b178f82f5f157b3696aa3e28f4a57d3c1a3c7e0693ee28285fc4295a891cea17'
AND (
token = 'TFpQ6CvCpErCqAefHB9XMxzlR5duJItxwIub0v/s1Vc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)