To fix the 'locate' database. And to properly update it

I tried to update the locate database, and for some reason it has been corrupted:

locate foo

locate: locate database header corrupt, bigram char outside 0, 32-127: -1

How to repair it? Or maybe I need to just update it to make it work? And finally, back to the original problem, *how* to update it? (Yes, there are many answers about this, but hey, I tried only the most upvoted ones, and the database has been corrupted. It seems the answers were outdated or macOS has some issues here: most answers were for Linux.) Sonoma 14.4.1, zsh 5.9 (x86_64-apple-darwin23.0)