Use the official CLI tool:
wp search-replace 'http://localhost' 'https://yoursitecom'
It will automatically deserialize any post meta, options, theme mods, etc and adjust them to match the new URL.
Fundamentally though, it’s bad practice to store URLs to images posts and assets in the database. Store the post ID instead, and this problem goes away