update uploaded_files
set file_name = 'dlbdi-logo.jpg',
    mime_type = 'image/jpeg',
    file_size = 5506,
    content_base64 = '',
    storage_driver = case
      when coalesce(storage_driver, '') = 's3' and coalesce(object_key, '') <> '' then storage_driver
      else 'pending'
    end,
    object_key = case
      when coalesce(storage_driver, '') = 's3' and coalesce(object_key, '') <> '' then object_key
      else ''
    end,
    storage_path = case
      when coalesce(storage_driver, '') = 's3' and coalesce(object_key, '') <> '' then storage_path
      else ''
    end,
    bucket = case
      when coalesce(storage_driver, '') = 's3' and coalesce(object_key, '') <> '' then bucket
      else ''
    end,
    checksum = case
      when coalesce(checksum, '') <> '' then checksum
      else '1d3907d843366cebd3d920da6fd1aa1fc27b6160be19f0e41ca08fde40d86d32'
    end,
    visibility = 'public',
    owner_type = 'site_asset',
    owner_id = 'brand_logo'
where id = 'd1b1d1b1-2026-4000-9000-000000000001'::uuid;
