SELECT * FROM tablename

WHERE id_one=27 OR id_two=27

ORDER BY

  CASE WHEN id_one=27 THEN timestamp_one END DESC,

  CASE WHEN id_two=27 THEN timestamp_two END DESC