The only way around this is randomizing the CSV filename. You'll have to do some house cleaning once in a while to get rid of the flood of files.
Creating a dummy empty CSV on Google Cloud Storage before the export with no cache control doesn't work. Don't even try. BigQuery overwrites it and changes the cache control to the default one.