Unfortunately all physical copies of Destiny: The Collection have expired codes. Bungie cannot issue new codes, so you will need to take it back to the retailer you purchased it from and request a refund as they sold you a defective product. The only way to get the DLC for sure is to purchase it from your console's store.
All Destiny 1 Codes have expired. You would need to contact the place where you purchased the code from , for a refund.