Thanks @pehar! I think my main problem might be the renaming operation. How do i rename both a raw file and all its connected XMP files (main sidecar and possibly duplicate manager sidecars)?
This is the command I used to set DateTimeOriginal tag for raw and sidecar simultaniously, in this case for all corresponding files in image-folder.
exiftool -DateTimeOriginal="1997:03:06 12:00:00" -overwrite_original -ext ARW -ext xmp /path/to/your/image-folder
In your case, you would need something like .../file-folder/basename with wildcards ? and/or *.
If you can’t rename your files using an exiftool one-liner, you could write a Bash script, if necessary with multiple calls to exiftool.