SELECT MAX( teplota1 )
FROM tabulka
WHERE UNIX_TIMESTAMP( `index` ) > UNIX_TIMESTAMP( CURDATE( ) - INTERVAL 31
DAY )
ORDER BY `index`
LIMIT 1