Well, many enthusiasts overclock their hardware willy nilly, fully confident that by the time their components die through excessive overclocks, they will have replaced them long ago with new technology. However, every piece of hardware is different, so while the above rule of thumb (i.e. it'll last for as long as you'll need it) may apply to many, the risk that something will give out early is always there (since video cards consist of many separate components - memory chips, GPU(s), voltage regulators, capacitors, etc).
With that out of the way, lets look at your video card. You have a 9200SE which, I am sorry to say, is at the very bottom of the performance ladder for video cards currently on the market. Thus, any overclock you apply may not result in a satisfactory performance increase since the card itself is held back in several other areas. What exactly are you trying to get faster frame rates in?