As long as the target is reasonable.
A cpu that'll last you, say 12 years, will bite the bullet at 11 with a mild OC.
Do an extreme one, and well... no telling with that one. Could be 6 years, 3 months, or 3 days from now - depends on how far you push it within reason.