Most high-performance ram with low CAS timings for it's speed bin are able to clock up or down according to your overclock as needed with corresponding adjustments to timings and voltage.
For example, you could buy DDR2-800 4-4-4-8 RAM and possibly run it at 1:1 at 333MHz at tighter timings (maybe 3-3-3-8) or if you overclock your FSB to 400MHz you could run the RAM at that speed at rated timings. Finally, if you overclock your FSB to 533MHz (good luck) then you could possibly run the same ram at 533MHz with 5-5-5-12 timings.
This only applies if you buy good performance RAM.