SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '31259502982dce60b1b7c9f2f7cd33e91bc4f8674bdda1053d5fb7a6931f48e8' 
  AND token = 'Hi508OsJpJBaap98XrQp3h3u9LFTJT4j6r2FEiJ3Y4Q=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00028

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}