When you purchase an expansion from a retail store, what you are actually purchasing is a code that will add funds to your console account. These funds can then be used to purchase the expansion from the Xbox Live / PSN store. If you have not completed this final step, check your account balance to ensure the funds from the cod you purchase are in your account, and then complete the purchase.