Update paths of latest MyMusic table of Music MySQL DB:

mysql -u kodi -p

use MyMusic82
UPDATE path SET strPath = REPLACE(strPath,'smb://my_nas/old_share', 'smb://my_nas/new_share');
exit

Update paths of latest MyVideo table of Movies/TV/MusicVideos MySQL DB:

mysql -u kodi -p

use MyVideos119
UPDATE path SET strPath = REPLACE(strPath,'smb://my_nas/old_share', 'smb://my_nas/new_share');
UPDATE movie SET c22 = REPLACE(c22,'smb://my_nas/old_share', 'smb://my_nas/new_share');
UPDATE episode SET c18 = REPLACE(c18,'smb://my_nas/old_share', 'smb://my_nas/new_share');
UPDATE art SET url = REPLACE(url,'smb://my_nas/old_share', 'smb://my_nas/new_share');
UPDATE tvshow SET c16 = REPLACE(c16,'smb://my_nas/old_share', 'smb://my_nas/new_share');
UPDATE files SET strFilename = REPLACE(strFilename,'smb://my_nas/old_share', 'smb://my_nas/new_share');
exit

Update paths of latest Textures13.db SQLite DB:

cd .kodi/userdata/Database
sqlite3 Textures13.db

UPDATE path SET url = REPLACE(url,'nfs://192.168.1.6/volume3/tv','nfs://192.168.1.6/volume5/tv');
UPDATE path SET texture = REPLACE(texture,'nfs://192.168.1.6/volume3/tv','nfs://192.168.1.6/volume5/tv');
.quit

https://kodi.wiki/view/HOW-TO:Update_SQL_databases_when_files_move