After several unsuccessfull attempts to fix a Vivaldi NO_PUBKEY error, I found this working solution:
wget -qO- https://repo.vivaldi.com/archive/linux_signing_key.pub | gpg --dearmor | sudo dd of=/usr/share/keyrings/vivaldi-browser.gpg
and then:
sudo apt update