MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table inquiry (
  id int primary key,
  userid int,
  productdescription json
);

insert into inquiry values
(327, 128, '[
  {"productkey":"yrty","productvalue":"700*600","quantity":"5","note":"round"},
  {"productkey":"c","productvalue":"600*4000","quantity":"1000","note":"notess"},
  {"productkey":"rtyrty","productvalue":"600*900","quantity":"3","note":"tertert"}
]');

create table providerinqlog (
  provider_id int,
  status_inq int,
  price_json json,
  time_json json
);

insert into providerinqlog values
(159, 2, '["70","30","60"]', '["3 mons","200","4 week"]');

select j.productkey, j.productvalue, 
  json_unquote(json_extract(providerinqlog.price_json, concat('$[', j.rownum, ']'))) as price,
  json_unquote(json_extract(providerinqlog.time_json, concat('$[', j.rownum, ']'))) as time
from inquiry
cross join json_table(inquiry.productdescription, '$[*]' columns (
    productkey varchar(10) path '$.productkey',
    productvalue varchar(10) path '$.productvalue',
    quantity int path '$.quantity',
    note text path '$.note',
    rownum for ordinality
  )) as j
cross join providerinqlog
where j.productkey = 'c' and j.productvalue = '600*4000'
 AND inquiry.userid=128
 and inquiry.id!=320
 and providerinqlog.provider_id=159
 and (providerinqlog.status_inq=2 OR providerinqlog.status_inq=3);

productkey	productvalue	price	time
c	600*4000	60	4 week