Re The redemption codes are valid until August 5, 2023 00:00 (UTC-4), redeem them in-game or click the link below:
https://genshin.hoyoverse.com/en/gift

https://twitter.com/GenshinImpact/status/1687444124629159937