update device_type
set logo = REPLACE(logo, '"}', '.png"}')
where logo not regexp '.png"}$' and logo != '';