YES. Even though a game may no longer be available on the Steam store, existing activation codes for the game are still valid and can be redeemed and added to your Steam games library.