No, there’s no way to overwrite it. From the docs:
file_name cannot be an existing file, which among other things prevents files such as /etc/passwd and database tables from being destroyed.
It might be a better idea to use a different filename each night, as having multiple backups means you can recover from problems that have existed for more than a day. You could then maintain a symlink that always points at the latest complete csv.