The hidden chamber, and the treasure it holds is only accessible while either X Marks The Spot or Treasure of The Sands mission is active, and even then it can only be visited once. The chamber holding the lost lost treasure is located on the southern side of the pyramid, second layer from the base - see the [Map].