Column in query should be selected according to value from another column
select t.price, t.id
from table1 t 
where (coffee_sender = tux and sent_bag_size= xl)
or (coffee_receiver = tux and received_bag_size= m)
or (coffee_sender = tux and sent_bag_size = xl AND coffee_receiver = tux and received_bag_size= m)