The code from Complete Edition will probably work just fine, but it will be a waste of money unless you can get it a heavy discount.
As mentioned, just buy the latest expansion (Endwalker) if you already have the base game. The latest expansion for FFXIV always includes all the older expansions as well.