Off the top of my head I think Metallica production was 5 years. It even went through several design updates (pro) with LEDs and redesigned backbox.
As far as code, Spider-man was released in 2007 and there was a (minor) update released in 2017. So that's 10 years.
Depending on title, I'm sure you can get a NIB pin 6 months after production stops, for a Pro at least. Probably can get a NIB WWE yet...maybe others.