WITH cte AS ( SELECT 'Valid from Thursday; 10 Aug 2017 03:40:01 UTC' as DateTimeString)
SELECT DateTimeString,
       STR_TO_DATE(SUBSTRING_INDEX(DateTimeString, ';', -1), '%d %b %Y %H:%i:%s UTC') as DateTimeResult
FROM cte;