SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '229b0be677f213d906a7797127e7dace50ccae412d3381b89b31cbcbe75e1505' 
  AND token = 'FY6HB7NdLM++EoOa6onCmiACI2FGlP+Sa+Db7xSchIE=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00046

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}