update vs
set vs.Value='/changepassword/changepassword.html?username={1}&resettoken={0}' 
from VendorSettings vs
	join VendorSettingsTypes t on t.id=vs.SettingTypeId
where t.RowId='7D987ABD-2A2F-408A-BDEF-CA6B8009EC47'