Replace URL using sed

Original Line

{background-image:url('http://www.myoldhost.com/images/scds/tsp3.png');}

Expected

{background-image:url('http://www.mynewhost.com/nndn/hddh/ccdcd.png');}

I am using following syntax

STATIC_HOST_TEMP="http://myhost.com/temp/xyx.png"

$sed -e "s/http:.*png/$STATIC_HOST_TEMP/g" tempfile.css

How can i replace url*in a css file
Example:

http://myoldhost.com/*/*/*.png to http://mynewhost.com/caca/acda.png 

Every time i run a sed it should push and replace the image url in my variable to css file

Thanks,
-V

Why not try this??

awk -F"'" -v new="http://www.mynewhost.com/nndn/hddh/ccdcd.png" '{$2=new}1' OFS="'" input.css