does deploy script in sandbox means it will deploy to production? or it will update the existing script with the changes?

No you have to deploy separately to production