This seems to indicate an issue with that particular mirror.
Try this instead:
sudo pacman-mirrors --continent
and when that completes, update with:
sudo pacman -Syu
I’ll note here the importance of updating from the official repositories with pacman before using an AUR helper such as yay.
The recommendation also appears in Known Issues and Solutions in each Update Announcement topic;