Put it right at the reveal beat, after the approach and before the inventory close-up, so the moment stays the focus of the edit. Follow it with a short celebration cue once the loot is shown, and save a tense cue for the guarded chest scenes that come later.