Locktite lasts forever or until you remove the cup, whichever happens first. You will need a lot of force to remove the cup if you use Blue Locktite but, that's why it's there.
As noted, don't use any of the high strength grades of Locktite (Locktite makes many grades for various applications) or you will need heat to remove the fitting and they aren't needed for bike applications anyway.