UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '396sxJ8DwPS2cfMGIZS4sAiO81vcOQhKlaVQiIhCkD4='
WHERE
key_id = 'a96dc3924f9f9259acb5910e8c592e715cc958b58117d866ba6935b884651370'
AND (
token = '396sxJ8DwPS2cfMGIZS4sAiO81vcOQhKlaVQiIhCkD4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)