In my limited experience, the only off road conditions you really need to air down for is rock crawling. All other conditions, the tread design has more to do with performance.
Tom, you should always air down to around 15 PSI for soft sand.
Gives the tyre a wider contact area so you don't bog down so easy.