SELECT 
  1 
FROM 
  cscart_aprillock_keys 
WHERE 
  key_id = '3e0367c12ce45711fc20461d6cd8a7d755935fa2562f8c1e835ea7c5d5450ff8' 
  AND token = 'CMux4NZ+18DMAU7ufa6wQPeOmIWTsAnFwamhFF6QF/Y=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00042

JSON explain

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