SELECT 
  1 
FROM 
  cscart_aprillock_keys 
WHERE 
  key_id = '23bfbeb7299a149543e7c022d09e2910a917d3b0872095a7b7040a1d23539816' 
  AND token = 'EB6dFf/vOzsc4I2kRW0lBR+wCGyad1q38UkTfgUGBJk=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00035

JSON explain

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