THIRD AMENDED AND RESTATED AGREEMENT OF LIMITED PARTNERSHIP OF CSI COMPRESSCO LP